﻿CREATE TRIGGER [dbo].[TRG_INVOICE_IN_ITEM_UPDATE]
   ON  dbo.INVOICE_IN_ITEM
   AFTER INSERT, UPDATE
AS
BEGIN
    SET NOCOUNT ON;

    UPDATE INVOICE_IN_ITEM
    SET LAST_UPDATE = GETDATE(), 
    LAST_UPDATE_USER = SUSER_NAME()
    WHERE ID IN (SELECT ID FROM INSERTED)
END
